Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	494
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	52.2 KiB
Average record size in memory	108.1 B

Variable types

NUM	12
CAT	3

Warnings

`Symbol` has constant value "494"	Constant
`Series` has constant value "494"	Constant
`Open Price` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Prev Close` is highly correlated with `Open Price` and 5 other fields	High correlation
`High Price` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low Price` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last Price` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close Price` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Average Price` is highly correlated with `Prev Close` and 5 other fields	High correlation
`No. of Trades` is highly correlated with `Total Traded Quantity` and 1 other fields	High correlation
`Total Traded Quantity` is highly correlated with `No. of Trades`	High correlation
`Turnover` is highly correlated with `No. of Trades`	High correlation
`Date` has unique values	Unique
`Total Traded Quantity` has unique values	Unique
`Turnover` has unique values	Unique
`No. of Trades` has unique values	Unique
`Deliverable Qty` has unique values	Unique

Reproduction

Analysis started	2020-09-12 09:00:42.868110
Analysis finished	2020-09-12 09:01:45.296644
Duration	1 minute and 2.43 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Symbol
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

RCOM	494

Frequencies
Length

Value	Count	Frequency (%)
RCOM	494	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Series
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

EQ	494

Frequencies
Length

Value	Count	Frequency (%)
EQ	494	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Date
Categorical

UNIQUE

Distinct	494
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

01-Aug-2017	1
07-Dec-2018	1
24-May-2017	1
05-Feb-2018	1
05-Jul-2017	1
Other values (489)	489

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
01-Aug-2017	1	0.2%
07-Dec-2018	1	0.2%
24-May-2017	1	0.2%
05-Feb-2018	1	0.2%
05-Jul-2017	1	0.2%
16-Aug-2017	1	0.2%
27-Sep-2018	1	0.2%
01-Feb-2019	1	0.2%
15-Jun-2018	1	0.2%
17-Jan-2018	1	0.2%
Other values (484)	484	98.0%

Frequencies of value counts

Unique

Unique	494 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Prev Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	314
Distinct (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.8201417
Minimum	1.85
Maximum	36.15
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.8975
Q1	12.9125
median	15.925
Q3	22.2875
95-th percentile	29.5025
Maximum	36.15
Range	34.3
Interquartile range (IQR)	9.375

Descriptive statistics

Standard deviation	7.322269665
Coefficient of variation (CV)	0.435327466
Kurtosis	-0.2555729794
Mean	16.8201417
Median Absolute Deviation (MAD)	4.275
Skewness	0.0955154412
Sum	8309.15
Variance	53.61563304
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.35	6	1.2%
13.55	6	1.2%
15.75	6	1.2%
13.85	6	1.2%
19.05	5	1.0%
13.5	5	1.0%
11.65	5	1.0%
13.8	4	0.8%
23.8	4	0.8%
14.1	4	0.8%
Other values (304)	443	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	2	0.4%
1.95	1	0.2%
2	2	0.4%
2.1	2	0.4%

Value	Count	Frequency (%)
36.15	1	0.2%
35.35	1	0.2%
34	1	0.2%
33.9	1	0.2%
33.3	1	0.2%

Open Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	309
Distinct (%)	62.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.86325911
Minimum	1.85
Maximum	37.25
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.78
Q1	12.9125
median	16
Q3	22.3375
95-th percentile	29.5375
Maximum	37.25
Range	35.4
Interquartile range (IQR)	9.425

Descriptive statistics

Standard deviation	7.368338006
Coefficient of variation (CV)	0.4369462604
Kurtosis	-0.2194136014
Mean	16.86325911
Median Absolute Deviation (MAD)	4.3
Skewness	0.1057878562
Sum	8330.45
Variance	54.29240498
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.7	9	1.8%
13.4	6	1.2%
13.3	6	1.2%
13.8	5	1.0%
13.95	5	1.0%
13.6	5	1.0%
25	4	0.8%
12	4	0.8%
13.9	4	0.8%
13.5	4	0.8%
Other values (299)	442	89.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	2	0.4%
1.95	1	0.2%
2	3	0.6%
2.1	2	0.4%

Value	Count	Frequency (%)
37.25	1	0.2%
35.25	1	0.2%
34.6	1	0.2%
34.35	1	0.2%
33.95	1	0.2%

High Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	305
Distinct (%)	61.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.44301619
Minimum	1.85
Maximum	40.15
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.83
Q1	13.3625
median	16.575
Q3	22.9
95-th percentile	30.8525
Maximum	40.15
Range	38.3
Interquartile range (IQR)	9.5375

Descriptive statistics

Standard deviation	7.612551476
Coefficient of variation (CV)	0.436424033
Kurtosis	-0.1577560441
Mean	17.44301619
Median Absolute Deviation (MAD)	4.475
Skewness	0.1090430051
Sum	8616.85
Variance	57.95093997
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.1	8	1.6%
17	6	1.2%
13.5	5	1.0%
23.5	5	1.0%
13.95	5	1.0%
13.7	5	1.0%
14.2	5	1.0%
16.1	4	0.8%
13.9	4	0.8%
16.3	4	0.8%
Other values (295)	443	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	1	0.2%
1.95	1	0.2%
2	2	0.4%
2.05	1	0.2%

Value	Count	Frequency (%)
40.15	1	0.2%
37.45	1	0.2%
36.15	1	0.2%
35.45	1	0.2%
34.9	1	0.2%

Low Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	292
Distinct (%)	59.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.2257085
Minimum	1.85
Maximum	33.95
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.7475
Q1	12.3125
median	15.45
Q3	21.65
95-th percentile	28.2025
Maximum	33.95
Range	32.1
Interquartile range (IQR)	9.3375

Descriptive statistics

Standard deviation	7.105001881
Coefficient of variation (CV)	0.4378854631
Kurtosis	-0.2873532686
Mean	16.2257085
Median Absolute Deviation (MAD)	4.2
Skewness	0.08697925847
Sum	8015.5
Variance	50.48105173
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.65	8	1.6%
13.75	7	1.4%
13.35	6	1.2%
16.75	6	1.2%
13.45	6	1.2%
22.65	5	1.0%
22	5	1.0%
22.1	4	0.8%
11.5	4	0.8%
11.65	4	0.8%
Other values (282)	439	88.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	2	0.4%
1.95	1	0.2%
2	3	0.6%
2.1	2	0.4%

Value	Count	Frequency (%)
33.95	1	0.2%
33.6	1	0.2%
33.35	1	0.2%
33.05	1	0.2%
32.7	1	0.2%

Last Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	308
Distinct (%)	62.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.77732794
Minimum	1.85
Maximum	36.3
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.7475
Q1	12.9125
median	15.85
Q3	22.3375
95-th percentile	29.2025
Maximum	36.3
Range	34.45
Interquartile range (IQR)	9.425

Descriptive statistics

Standard deviation	7.312128505
Coefficient of variation (CV)	0.4358339143
Kurtosis	-0.2498493279
Mean	16.77732794
Median Absolute Deviation (MAD)	4.275
Skewness	0.08170976461
Sum	8288
Variance	53.46722327
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.9	8	1.6%
13.55	6	1.2%
13.6	5	1.0%
13.65	5	1.0%
23	5	1.0%
15.85	5	1.0%
11.6	5	1.0%
14.4	5	1.0%
13.95	4	0.8%
16.85	4	0.8%
Other values (298)	442	89.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	2	0.4%
1.95	1	0.2%
2	2	0.4%
2.1	2	0.4%

Value	Count	Frequency (%)
36.3	1	0.2%
35.1	1	0.2%
33.95	1	0.2%
33.9	1	0.2%
33.85	1	0.2%

Close Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	313
Distinct (%)	63.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.75910931
Minimum	1.85
Maximum	36.15
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.7475
Q1	12.8625
median	15.9
Q3	22.2375
95-th percentile	29.45
Maximum	36.15
Range	34.3
Interquartile range (IQR)	9.375

Descriptive statistics

Standard deviation	7.317378936
Coefficient of variation (CV)	0.4366209922
Kurtosis	-0.2566461148
Mean	16.75910931
Median Absolute Deviation (MAD)	4.25
Skewness	0.08507045313
Sum	8279
Variance	53.5440345
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.55	6	1.2%
15.75	6	1.2%
13.85	6	1.2%
13.35	6	1.2%
19.05	5	1.0%
13.5	5	1.0%
11.65	5	1.0%
13.7	4	0.8%
14.1	4	0.8%
15.65	4	0.8%
Other values (303)	443	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	2	0.4%
1.95	1	0.2%
2	2	0.4%
2.1	2	0.4%

Value	Count	Frequency (%)
36.15	1	0.2%
35.35	1	0.2%
34	1	0.2%
33.9	1	0.2%
33.3	1	0.2%

Average Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	448
Distinct (%)	90.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.8215587
Minimum	1.85
Maximum	36.58
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1.85
5-th percentile	3.767
Q1	12.87
median	15.91
Q3	22.4125
95-th percentile	29.657
Maximum	36.58
Range	34.73
Interquartile range (IQR)	9.5425

Descriptive statistics

Standard deviation	7.355213561
Coefficient of variation (CV)	0.4372492282
Kurtosis	-0.2427677812
Mean	16.8215587
Median Absolute Deviation (MAD)	4.255
Skewness	0.09294748374
Sum	8309.85
Variance	54.09916653
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.87	3	0.6%
2.4	3	0.6%
13.83	3	0.6%
14.13	2	0.4%
13.84	2	0.4%
28.82	2	0.4%
13.71	2	0.4%
22.52	2	0.4%
21.29	2	0.4%
5.32	2	0.4%
Other values (438)	471	95.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.85	1	0.2%
1.9	1	0.2%
1.92	1	0.2%
1.95	1	0.2%
2	2	0.4%

Value	Count	Frequency (%)
36.58	1	0.2%
35.68	1	0.2%
34.87	1	0.2%
34.01	1	0.2%
33.34	1	0.2%

Total Traded Quantity
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	494
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	81814773.31
Minimum	2367025
Maximum	827714011
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	2367025
5-th percentile	8931096.25
Q1	32475402
median	56953703
Q3	93166704.5
95-th percentile	247548615.7
Maximum	827714011
Range	825346986
Interquartile range (IQR)	60691302.5

Descriptive statistics

Standard deviation	96977318.89
Coefficient of variation (CV)	1.185327722
Kurtosis	22.3314008
Mean	81814773.31
Median Absolute Deviation (MAD)	29261214.5
Skewness	4.053221929
Sum	4.041649801e+10
Variance	9.404600378e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201135102	1	0.2%
100285154	1	0.2%
92640562	1	0.2%
55758132	1	0.2%
24864059	1	0.2%
17838396	1	0.2%
264930325	1	0.2%
19041611	1	0.2%
15522124	1	0.2%
45185360	1	0.2%
Other values (484)	484	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2367025	1	0.2%
2377164	1	0.2%
2617494	1	0.2%
3027180	1	0.2%
3584592	1	0.2%

Value	Count	Frequency (%)
827714011	1	0.2%
781836478	1	0.2%
774653485	1	0.2%
685286689	1	0.2%
556849068	1	0.2%

Turnover
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	494
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1489669927
Minimum	4734050
Maximum	2.506661893e+10
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	4734050
5-th percentile	99812740.12
Q1	465384016.9
median	800408584.7
Q3	1597793883
95-th percentile	4326567372
Maximum	2.506661893e+10
Range	2.506188488e+10
Interquartile range (IQR)	1132409866

Descriptive statistics

Standard deviation	2484907442
Coefficient of variation (CV)	1.66809264
Kurtosis	44.63801603
Mean	1489669927
Median Absolute Deviation (MAD)	433619202.1
Skewness	5.874509422
Sum	7.358969441e+11
Variance	6.174764993e+18
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300626870.4	1	0.2%
797126244	1	0.2%
1228306957	1	0.2%
352217019.1	1	0.2%
927354937.4	1	0.2%
666200143.8	1	0.2%
98872774.5	1	0.2%
1353485138	1	0.2%
381476210.7	1	0.2%
1582132377	1	0.2%
Other values (484)	484	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4734050	1	0.2%
4992044.4	1	0.2%
5104113.3	1	0.2%
6659796	1	0.2%
8603020.8	1	0.2%

Value	Count	Frequency (%)
2.506661893e+10	1	0.2%
2.503625078e+10	1	0.2%
2.146104751e+10	1	0.2%
1.475117543e+10	1	0.2%
1.423465799e+10	1	0.2%

No. of Trades
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	494
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	56062.12146
Minimum	1408
Maximum	648577
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1408
5-th percentile	7206.65
Q1	21688
median	38198
Q3	61075.5
95-th percentile	145938.65
Maximum	648577
Range	647169
Interquartile range (IQR)	39387.5

Descriptive statistics

Standard deviation	71264.93347
Coefficient of variation (CV)	1.271177965
Kurtosis	31.96400336
Mean	56062.12146
Median Absolute Deviation (MAD)	18386.5
Skewness	4.885417847
Sum	27694688
Variance	5078690743
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33790	1	0.2%
22858	1	0.2%
50510	1	0.2%
39249	1	0.2%
19796	1	0.2%
58709	1	0.2%
3418	1	0.2%
14346	1	0.2%
3933	1	0.2%
34145	1	0.2%
Other values (484)	484	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1408	1	0.2%
1527	1	0.2%
1560	1	0.2%
2385	1	0.2%
2791	1	0.2%

Value	Count	Frequency (%)
648577	1	0.2%
639231	1	0.2%
591969	1	0.2%
586307	1	0.2%
349227	1	0.2%

Deliverable Qty
Real number (ℝ_≥0)

UNIQUE

Distinct	494
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11703466.1
Minimum	1166757
Maximum	81671630
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	1166757
5-th percentile	2611888.85
Q1	5204915
median	8018975.5
Q3	12782847
95-th percentile	33890206.4
Maximum	81671630
Range	80504873
Interquartile range (IQR)	7577932

Descriptive statistics

Standard deviation	11563782.37
Coefficient of variation (CV)	0.9880647556
Kurtosis	10.97018548
Mean	11703466.1
Median Absolute Deviation (MAD)	3349606
Skewness	2.96949147
Sum	5781512251
Variance	1.337210626e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8168858	1	0.2%
5200220	1	0.2%
6579552	1	0.2%
6929762	1	0.2%
6779235	1	0.2%
7021726	1	0.2%
9121298	1	0.2%
6313320	1	0.2%
26867050	1	0.2%
13786476	1	0.2%
Other values (484)	484	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1166757	1	0.2%
1220396	1	0.2%
1376836	1	0.2%
1399815	1	0.2%
1442437	1	0.2%

Value	Count	Frequency (%)
81671630	1	0.2%
78830388	1	0.2%
70135068	1	0.2%
70128853	1	0.2%
69305961	1	0.2%

% Dly Qt to Traded Qty
Real number (ℝ_≥0)

Distinct	443
Distinct (%)	89.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.64740891
Minimum	5.37
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	3.9 KiB

Quantile statistics

Minimum	5.37
5-th percentile	8.1095
Q1	10.8625
median	14.075
Q3	20.2475
95-th percentile	69.926
Maximum	100
Range	94.63
Interquartile range (IQR)	9.385

Descriptive statistics

Standard deviation	19.82243103
Coefficient of variation (CV)	0.9600444838
Kurtosis	8.167241698
Mean	20.64740891
Median Absolute Deviation (MAD)	3.945
Skewness	2.914780478
Sum	10199.82
Variance	392.9287718
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	10	2.0%
12.87	3	0.6%
8.58	3	0.6%
12.18	2	0.4%
11.89	2	0.4%
13.35	2	0.4%
19.82	2	0.4%
10.87	2	0.4%
8.97	2	0.4%
10.19	2	0.4%
Other values (433)	464	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5.37	1	0.2%
5.66	1	0.2%
5.72	1	0.2%
5.94	1	0.2%
5.95	1	0.2%

Value	Count	Frequency (%)
100	10	2.0%
99.94	1	0.2%
99.76	1	0.2%
99.64	1	0.2%
99.57	1	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Symbol	Series	Date	Prev Close	Open Price	High Price	Low Price	Last Price	Close Price	Average Price	Total Traded Quantity	Turnover	No. of Trades	Deliverable Qty	% Dly Qt to Traded Qty
0	RCOM	EQ	15-May-2017	32.45	32.50	32.60	31.70	32.00	32.00	31.99	7126316	2.279973e+08	11883	1908042	26.77
1	RCOM	EQ	16-May-2017	32.00	32.05	32.35	31.85	32.00	32.10	32.12	7274881	2.336877e+08	9976	2211910	30.40
2	RCOM	EQ	17-May-2017	32.10	32.10	32.30	31.70	31.90	31.95	31.97	6245114	1.996360e+08	8838	1399815	22.41
3	RCOM	EQ	18-May-2017	31.95	31.60	31.90	31.00	31.05	31.05	31.34	11189938	3.506776e+08	17051	3629175	32.43
4	RCOM	EQ	19-May-2017	31.05	31.20	31.45	30.25	30.55	30.55	30.80	11898780	3.664547e+08	18065	3309529	27.81
5	RCOM	EQ	22-May-2017	30.55	30.75	30.80	29.70	29.90	29.80	30.08	10150535	3.053526e+08	19810	3463929	34.13
6	RCOM	EQ	23-May-2017	29.80	29.70	29.80	27.20	27.95	28.00	28.16	25930820	7.300927e+08	42741	5472973	21.11
7	RCOM	EQ	24-May-2017	28.00	28.00	28.20	25.30	25.90	25.90	26.34	46243616	1.218051e+09	60442	12211614	26.41
8	RCOM	EQ	25-May-2017	25.90	25.90	26.55	25.15	26.20	25.95	25.90	28257448	7.318248e+08	35034	6872713	24.32
9	RCOM	EQ	26-May-2017	25.95	26.00	26.30	25.35	25.95	25.75	25.93	14024830	3.636344e+08	20142	4643580	33.11

Last rows

	Symbol	Series	Date	Prev Close	Open Price	High Price	Low Price	Last Price	Close Price	Average Price	Total Traded Quantity	Turnover	No. of Trades	Deliverable Qty	% Dly Qt to Traded Qty
484	RCOM	EQ	26-Apr-2019	2.00	1.90	2.05	1.90	1.90	1.90	1.92	66133254	1.268149e+08	14346	34175624	51.68
485	RCOM	EQ	30-Apr-2019	1.90	1.85	1.85	1.85	1.85	1.85	1.85	22861426	4.229364e+07	4372	22336425	97.70
486	RCOM	EQ	02-May-2019	1.85	1.90	1.90	1.90	1.90	1.90	1.90	16688044	3.170728e+07	3933	16182408	96.97
487	RCOM	EQ	03-May-2019	1.90	1.95	1.95	1.95	1.95	1.95	1.95	2617494	5.104113e+06	1527	2617394	100.00
488	RCOM	EQ	06-May-2019	1.95	2.00	2.00	2.00	2.00	2.00	2.00	2367025	4.734050e+06	1408	2367025	100.00
489	RCOM	EQ	07-May-2019	2.00	2.00	2.10	2.00	2.10	2.10	2.06	64199212	1.325275e+08	9103	34677474	54.02
490	RCOM	EQ	08-May-2019	2.10	2.10	2.20	2.10	2.20	2.20	2.18	27455636	5.972756e+07	4208	14957834	54.48
491	RCOM	EQ	09-May-2019	2.20	2.30	2.30	2.30	2.30	2.30	2.30	7854126	1.806449e+07	2385	7711773	98.19
492	RCOM	EQ	10-May-2019	2.30	2.40	2.40	2.40	2.40	2.40	2.40	3584592	8.603021e+06	1560	3584592	100.00
493	RCOM	EQ	13-May-2019	2.40	2.45	2.50	2.30	2.30	2.30	2.40	42329516	1.014503e+08	9541	26309575	62.15

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows